C/C++ Users Group Library 1996 July/C-C++ Users Group Library July 1996.iso/listings/v_02_09/2n09060b

Text File | 1991-07-30 | 423 b | 13 lines

INSERT INTO KeyChanger (oldreg#, oldoutlet#,
                        newreg#, newoutlet#)
SELECT Upd1.reg#, Upd1.outlet#,
       Upd2.reg#, Upd2.outlet#
  FROM UpdateList Upd1, UpdateList Upd2
 WHERE ( (Upd1.action = "B") AND (Upd2.action = "C"))
   AND ( (Upd1.name = Upd2.name)
   AND (Upd1.street = Upd2.street)
   AND (Upd1.city = Upd2.city)
   AND (Upd1.state = Upd2.state)
   AND (Upd1.zip = Upd2.zip));